{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Notes Balance","Cumulative Defaults","Collateral Tables"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":7,"defined_names":24,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Notes Balance","index":0,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"SUM(C3:G3)","v":507600000},483300000,0,13500000,10800000]
["Invested Amount as at Previous Payment Date:  17 May 2021",{"$f":"SUM(C4:G4)","v":507600000},483300000,0,13500000,10800000]
["Stated Amount as at Previous Payment Date:  17 May 2021",507600000,483300000,0,13500000,10800000]
["Principal Payments to Noteholders on Payment Date",68701598.230000004,68701598.230000004,0,0,0]
["Gross Aggregate Charge-Offs",0,0,0,0,0]
["Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",{"$f":"SUM(C10:G10)","v":0},0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
["Invested Amount as at Payment Date:  16 August 2021",438898401.76999998,414598401.76999998,0,13500000,10800000]
["Stated Amount as at Payment Date:  16 August 2021",438898401.76999998,414598401.76999998,0,13500000,10800000]
["Bond Factor at Payment Date:  16 August 2021",null,0.8578489587626732,0,1,1]
["Coupon Margin",null,7.0000000000000001E-3,0,0,0]
["Coupon Rate (3 month BBSW + margin)",null,7.3940000000000004E-3,3.9399999999999998E-4,3.9399999999999998E-4,3.9399999999999998E-4]
["Days in Coupon Period",null,91,91,91,91]
["Coupon Entitlement to be paid out on the current Payment Date: 16 August 2021",null,890932.43,0,1326.11,1060.8900000000001]
[]
[]
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"+SUM(C25:F25)","v":507600000},483300000,0,13500000,10800000]
["Invested Amount as at Previous Payment Date:  16 August 2021",{"$f":"+SUM(C26:F26)","v":438898401.76999998},414598401.76999998,0,13500000,10800000]
["Stated Amount as at Previous Payment Date:  16 August 2021",438898401.76999998,414598401.76999998,0,13500000,10800000]
["Principal Payments to Noteholders on Payment Date",28325836.690000001,28325836.690000001,0,0,0]
["Gross Aggregate Charge-Offs",0,0,0,0,0]
["Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
["Invested Amount as at Payment Date:  16 November 2021",410572565.07999998,386272565.07999998,0,13500000,10800000]
["Stated Amount as at Payment Date:  16 November 2021",410572565.07999998,386272565.07999998,0,13500000,10800000]
["Bond Factor at Payment Date:  16 November 2021",null,0.7992397373887854,0,1,1]
["Coupon Margin",null,7.0000000000000001E-3,0,0,0]
["Coupon Rate (3 month BBSW + margin)",null,7.1570000000000002E-3,1.5699999999999999E-4,1.5699999999999999E-4,1.5699999999999999E-4]
["Days in Coupon Period",null,92,92,92,92]
["Coupon Entitlement to be paid out on the current Payment Date: 16 November 2021",null,747917.34,0,534.23,427.38]

{"sheet":"Cumulative Defaults","index":1,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Cumulative Defaults & Losses"]
[]
["Month","Gross Losses","Recoveries","Net Losses"]
["2021-07-01",{"$f":"+'Collateral Tables'!I9/540000000","v":0},{"$f":"'Collateral Tables'!I23/540000000","v":0},{"$f":"+B4-C4","v":0}]
["2021-10-01",{"$f":"+'Collateral Tables'!E9/540000000","v":0},{"$f":"+'Collateral Tables'!E23/540000000","v":0},{"$f":"+B5-C5","v":0}]

{"sheet":"Collateral Tables","index":2,"n_rows":255,"n_cols":11,"rows_kept":255,"cut":false,"hidden":false,"merged":[]}
[null,"CNHI CAPITAL AUSTRALIA RECEIVABLES TRUST SERIES 2021-1 (TERM DEAL)"]
[null,"COLLATERAL DATA TABLES"]
[]
[null,"OUTSTANDING RECEIVABLES",null,null,"2021-10-31",null,null,null,"2021-07-31"]
[]
[null,"Opening Balance",null,null,{"$f":"'[1]16 Nov 21'!M163","v":471298401.76999968},null,null,null,539999974.61999965]
[null,"Principal Repayments - Scheduled",null,null,{"$f":"MIN(([2]Sheet1!$B$3+[3]Sheet1!$B$3+[4]Sheet1!$B$3),'[1]16 Nov 21'!H23)","v":21375090.149999995},null,null,null,59422745.440000013]
[null,"Principal Repayments - Unscheduled",null,null,{"$f":"'[1]16 Nov 21'!H23-'Collateral Tables'!E7","v":6950746.540000014},null,null,null,9278827.4099999517]
[{"$f":"SUM(E9:I9)","v":0},"Charge-Offs",null,null,{"$f":"'[1]16 Nov 21'!D37","v":0},null,null,null,0]
[null,"Reinstatements"]
[null,"New Receivables Purchased"]
[null,"Non Cash Change in Receivables"]
[null,"Closing Balance",null,null,{"$f":"E6-E7-E8-E9+E10+E11-E12","v":442972565.07999969},null,null,null,471298401.76999968]
[]
[null,"PORTFOLIO STATISTICS"]
[]
[null,"Summary"]
[null,"Number of contracts",null,null,{"$f":"[5]Summary!$B$4","v":4503},null,null,null,4717]
[null,"Dollar value of contracts",null,null,{"$f":"[5]Summary!$B$5","v":442972565.0799998},null,null,null,471298401.76999849]
[null,"Number of contracts closed during the Quarter",null,null,{"$f":"[5]Summary!$B$19","v":214},null,null,null,227]
[null,"Dollar value of contracts closed during the Quarter",null,null,{"$f":"[5]Summary!$B$20","v":9889285.4700000044},null,null,null,15873333.849999998]
[]
[{"$f":"SUM(E23:I23)","v":0},"Dollar Value of Recoveries from Collateral",null,null,{"$f":"[5]Summary!$C$16","v":0},null,null,null,0]
[{"$f":"SUM(E24:I24)","v":0},"Dollar Value of Recoveries from Other Sources",null,null,0,null,null,null,0]
[]
[null,"Average Term of Contracts (Months)",null,null,{"$f":"[6]Sheet1!$W$4505","v":54.72447090070245},null,null,null,54.491598918116452]
[null,"Average Term to Maturity (Months)",null,null,{"$f":"[6]Sheet1!$X$4505","v":37.45208747599041},null,null,null,39.996367531539505]
[null,"Average Residual / Balloon Payment *",null,null,{"$f":"[6]Sheet1!$AI$4505","v":4.6197075252970211E-2},null,null,null,4.7495394520798505E-2]
[null,"Average Seasoning (Months)",null,null,{"$f":"E26-E27","v":17.272383424712039},null,null,null,14.495231386576947]
[null,"Average Dollar Value of Individual Assets",null,null,{"$f":"E19/E18","v":98372.765951587789},null,null,null,99914.861515793615]
[null,"Weighted Average Interest Rate",null,null,{"$f":"[6]Sheet1!$AA$4505/100","v":2.1890989732123292E-2},null,null,null,2.1995904554703908E-2]
[]
[null,"Payment in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A34,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":4496},{"$f":"IFERROR(VLOOKUP($A34,'[7]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":110119.20999999996},{"$f":"F34/F$50","v":2.4859149003982376E-4},null,4712,195906.98,4.1567503574010831E-4]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A35,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":5},{"$f":"IFERROR(VLOOKUP($A35,'[7]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":253453.39999999997},5.7216500519445687E-4,null,4,147584.37,3.1314421913109658E-4]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A36,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A36,'[7]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":0},0,null,1,20086.370000000003,4.2619219425663342E-5]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A37,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A37,'[7]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":14297.29},3.2275791159702955E-5,null,0,0,0]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A38,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A38,'[7]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":96095.999999999985},2.1693442794283496E-4,null,0,0,0]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A39,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A39,'[7]Arrears Reporting'!$A$1:$D$8,2,FALSE),0)","v":0},0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E34:E39)","v":4503},{"$f":"SUM(F34:F39)","v":473965.89999999991},{"$f":"SUM(G34:G39)","v":1.0699667143368185E-3},null,4717,363577.72,7.7143847429686821E-4]
[null,"* Expressed as a % of Aggreg. Rec. closing bal.",null,null,null,"> 30 days",{"$f":"SUM(G35:G39)","v":8.2137522429699477E-4},null,null,"> 30 days",3.5576343855675991E-4]
[]
[" 0 - 30 Days","Account Balances in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A44,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":4496},{"$f":"IFERROR(VLOOKUP($A44,'[7]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":441358176.30999982},{"$f":"F44/F$50","v":0.99635555585771229},null,4712,470790435.33999842,0.99892219785152614]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A45,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":5},{"$f":"IFERROR(VLOOKUP($A45,'[7]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":1388190.9000000001},{"$f":"F45/F$50","v":3.1338078459764119E-3},null,4,272648.59999999998,5.7850525055049321E-4]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A46,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A46,'[7]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":0},0,null,1,235317.83,4.9929689792336499E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A47,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A47,'[7]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":135254.64000000001},{"$f":"F47/F$50","v":3.0533412374098912E-4},null,0,0,0]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A48,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A48,'[7]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":90943.23},{"$f":"F48/F$50","v":2.053021725703845E-4},null,0,0,0]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A49,'[7]Arrears Reporting'!$A$1:$D$8,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A49,'[7]Arrears Reporting'!$A$1:$D$8,4,FALSE),0)","v":0},{"$f":"F49/F$50","v":0},null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E44:E49)","v":4503},{"$f":"SUM(F44:F49)","v":442972565.0799998},{"$f":"SUM(G44:G49)","v":1},null,4717,471298401.76999843,1]
["NSW",null,null,null,null,"> 30 days",{"$f":"SUM(G45:G49)","v":3.6444441422877859E-3},null,null,"> 30 days",1.0778021484738583E-3]
[null,null,null,null,null,"> 60 days",{"$f":"SUM(G46:G49)","v":5.1063629631137363E-4},null,null,"> 60 days",4.9929689792336499E-4]
[null,null,null,null,null,">90 days",{"$f":"SUM(G47:G49)","v":5.1063629631137363E-4},null,null,">90 days",0]
[]
["VIC","Geographic Distribution"]
["NSW","New South Wales",null,null,{"$f":"F56/F$64","v":0.33118214877146057},{"$f":"IFERROR(VLOOKUP($A56,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":146704605.95000011},null,null,0.33103569692591123,156016594.89000008]
["VIC","Victoria",null,null,{"$f":"F57/F$64","v":0.21139368986223459},{"$f":"IFERROR(VLOOKUP($A57,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":93641605.040000081},null,null,0.21226914626547361,100042109.38000008]
["QLD","Queensland",null,null,0.10124455450621518,{"$f":"IFERROR(VLOOKUP($A58,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":44848560.010000028},null,null,0.10435840061261739,49183947.419999972]
["SA","South Australia",null,null,0.15665609775961517,{"$f":"IFERROR(VLOOKUP($A59,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":69394353.459999993},null,null,0.15537976293782821,73230233.939999923]
["NT","Northern Territory",null,null,1.6321954382647244E-4,{"$f":"IFERROR(VLOOKUP($A60,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":72301.78},null,null,1.5340977123721341E-4,72301.78]
["ACT","Australian Capital Territory",null,null,2.1870392804688407E-4,{"$f":"IFERROR(VLOOKUP($A61,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":96879.840000000026},null,null,2.0555944946165698E-4,96879.840000000026]
["TAS","Tasmania",null,null,1.7017469690563346E-2,{"$f":"IFERROR(VLOOKUP($A62,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":7538272.200000002},null,null,1.8092037354629446E-2,8526748.2899999972]
["WA","Western Australia",null,null,0.18212411593803798,{"$f":"IFERROR(VLOOKUP($A63,'[7]Geographic '!$A$1:$C$10,3,FALSE),0)","v":80675986.800000027},null,null,0.17850598668284129,84129586.230000004]
[null,"Total",null,null,{"$f":"SUM(E56:E63)","v":1.0000000000000002},{"$f":"SUM(F56:F63)","v":442972565.08000016},null,null,1,471298401.77000004]
["AG",null,null,null,null,null,{"$f":"E13-F64","v":-4.76837158203125E-7},null,null,null,0]
["CE","Top Industry Distribution"]
["AGRICULTURAL MACHINERY","Agricultural",null,null,{"$f":"F67/F$70","v":0.9491182301415676},{"$f":"IFERROR(VLOOKUP($A$67,'[7]Top Industry'!$A$1:$C$4,3,FALSE),)","v":420433336.96999979},null,null,0.94569648368447079,445705241.3199988]
["CONSTRUCTION EQUIPMENT","Construction",null,null,{"$f":"F68/F$70","v":5.0881769858432353E-2},{"$f":"IFERROR(VLOOKUP($A$68,'[7]Top Industry'!$A$1:$C$4,3,FALSE),)","v":22539228.109999999},null,null,5.4303516315529272E-2,25593160.449999999]
["MOTOR VEHICLE - AG","Motor Vehicle AG",null,null,{"$f":"F69/F$70","v":0},{"$f":"IFERROR(VLOOKUP($A$69,'[7]Top Industry'!$A$1:$C$4,3,FALSE),)","v":0},null,null,0,0]
[null,"Total",null,null,{"$f":"SUM(E67:E69)","v":1},{"$f":"SUM(F67:F69)","v":442972565.0799998},{"$f":"F64-F70","v":0},null,1,471298401.76999879,1.2516975402832031E-6]
["COMBINE"]
["40-100 HP TRACTOR","Collateral Types"]
["100<140 HP TRACTOR","100<140 HP TRACTOR",null,null,{"$f":"IFERROR(F73/F$116,0)","v":0.10526080036486933},{"$f":"IFERROR(VLOOKUP($A73,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":46627646.739999965},null,null,0.10636572878612072,50129997.979999989]
["4 EWD TRACTORS","4 EWD TRACTORS",null,null,9.9431621306040607E-2,{"$f":"IFERROR(VLOOKUP($A74,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":44045480.339999989},null,null,9.6039692729722251E-2,45263353.689999998]
["40<60 HP TRACTOR","40<60 HP TRACTOR",null,null,1.3569863291453297E-2,{"$f":"IFERROR(VLOOKUP($A75,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":6011077.1499999985},null,null,1.4664640202562935E-2,6911421.4900000021]
["4WD Vehicle","4WD Vehicle",null,null,2.1459950004540812E-3,{"$f":"IFERROR(VLOOKUP($A76,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":950616.91},null,null,2.1102970353066635E-3,994579.62]
["60<100 HP TRACTOR","60<100 HP TRACTOR",null,null,4.401010635157325E-2,{"$f":"IFERROR(VLOOKUP($A77,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":19495269.700000003},null,null,4.5290810619843497E-2,21345486.659999989]
["BACKHOE","BACKHOE",null,null,6.4766462444053807E-4,{"$f":"IFERROR(VLOOKUP($A78,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":286897.65999999997},null,null,6.7775056906703142E-4,319422.75999999995]
["BALERS, WINDROWERS, MOWERS, RAKES","BALERS, WINDROWERS, MOWERS, RAKES",null,null,4.641457690791035E-2,{"$f":"IFERROR(VLOOKUP($A79,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":20560384.189999983},null,null,4.8041674414694008E-2,22641964.36999999]
["COMBINES","COMBINES",null,null,0.29205535906413432,{"$f":"IFERROR(VLOOKUP($A80,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":129372511.55000001},null,null,0.29169772327615578,137476670.77999997]
["COMPACT TRACK LOADER","COMPACT TRACK LOADER",null,null,6.0206096274119164E-3,{"$f":"IFERROR(VLOOKUP($A81,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":2666964.8899999997},null,null,6.7614079700510487E-3,3186640.77]
["COMPACT WHEEL LOADER","COMPACT WHEEL LOADER",null,null,1.1666414824283049E-3,{"$f":"IFERROR(VLOOKUP($A82,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":516790.16999999993},null,null,1.214799472796438E-3,572533.04999999993]
["COTTON PICKERS","COTTON PICKERS",null,null,1.4762766851755204E-3,{"$f":"IFERROR(VLOOKUP($A83,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":653950.06999999983},null,null,1.387549941913735E-3,653950.06999999983]
["CRAWLER EXCAVATOR","CRAWLER EXCAVATOR",null,null,1.4517343571466128E-2,{"$f":"IFERROR(VLOOKUP($A84,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":6430784.919999999},null,null,1.4749377281767987E-2,6951357.9400000004]
["CRAWLER  DOZER","CRAWLER  DOZER",null,null,9.0901349596510304E-4,{"$f":"IFERROR(VLOOKUP($A85,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":402668.03999999992},null,null,9.2942570642063802E-4,438036.85000000003]
["CULTIVATORS,SEEDERS, HARROWS","CULTIVATORS,SEEDERS, HARROWS",null,null,2.1544219218805259E-2,{"$f":"IFERROR(VLOOKUP($A86,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":9543498.0499999989},null,null,2.0775771322853805E-2,9791587.8199999984]
["DRILL","DRILL",null,null,2.8008966870802219E-3,{"$f":"IFERROR(VLOOKUP($A87,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":1240720.3899999999},null,null,2.6756069727038654E-3,1261009.29]
["DUMP TRUCKS","DUMP TRUCKS",null,null,0,{"$f":"IFERROR(VLOOKUP($A88,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":""},null,null,0,""]
["EXCAVATORS / GRADERS","EXCAVATORS / GRADERS",null,null,1.3621026392255953E-4,{"$f":"IFERROR(VLOOKUP($A89,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":60337.409999999974},null,null,3.8207468840065635E-4,180071.19000000012]
["FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE","FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE",null,null,3.7928676004947851E-3,{"$f":"IFERROR(VLOOKUP($A90,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":1680136.2899999996},null,null,3.7479038616855254E-3,1766381.0999999996]
["FRONT END LOADER","FRONT END LOADER",null,null,4.93966437764566E-4,{"$f":"IFERROR(VLOOKUP($A91,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":218813.58},null,null,5.4164463329663104E-4,255276.25]
["FRONTS","FRONTS",null,null,5.127360200263895E-3,{"$f":"IFERROR(VLOOKUP($A92,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":2271279.9},null,null,4.9665274934293149E-3,2340716.4700000007]
["GRADER","GRADER",null,null,1.7910154996996679E-3,{"$f":"IFERROR(VLOOKUP($A93,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":793370.72999999986},null,null,1.8662446057460555E-3,879558.09999999986]
["HARVESTERS - Other","HARVESTERS - Other",null,null,1.2374488155965237E-2,{"$f":"IFERROR(VLOOKUP($A94,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":5481558.7599999998},null,null,1.2703868626573207E-2,5987312.9799999986]
["IRRIGATION EQUIPMENT","IRRIGATION EQUIPMENT",null,null,7.3387170138017527E-4,{"$f":"IFERROR(VLOOKUP($A95,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":325085.03000000003},null,null,6.8976476215305707E-4,325085.03000000003]
["MATERIALS HANDLING EQUIPMENT","MATERIALS HANDLING EQUIPMENT",null,null,6.5382261302727443E-4,{"$f":"IFERROR(VLOOKUP($A96,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":289625.48},null,null,8.0445995270959068E-4,379140.68999999994]
["MIDI CRAWLER EXCAVATOR","MIDI CRAWLER EXCAVATOR",null,null,1.3622053769651028E-3,{"$f":"IFERROR(VLOOKUP($A97,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":603419.60999999987},null,null,1.7386493714440583E-3,819422.66999999993]
["MINI EXCAVATOR","MINI EXCAVATOR",null,null,3.9545820172489322E-3,{"$f":"IFERROR(VLOOKUP($A98,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":1751771.3400000003},null,null,4.1419469972076147E-3,1952092.9999999998]
["OTHER AG","OTHER AG",null,null,3.5445235524155724E-3,{"$f":"IFERROR(VLOOKUP($A99,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":1570126.69},null,null,4.3436494635070693E-3,2047155.05]
["OTHER CE","OTHER CE",null,null,1.5603587095177585E-4,{"$f":"IFERROR(VLOOKUP($A100,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":69119.61},null,null,1.5640248242550282E-4,73712.240000000005]
["OVER 140 HP TRACTOR","OVER 140 HP TRACTOR",null,null,0.20159087013407426,{"$f":"IFERROR(VLOOKUP($A101,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":89299224.840000033},null,null,0.19897082703404384,93774632.779999986]
["QUAD BIKES","QUAD BIKES",null,null,2.7999702414437379E-5,{"$f":"IFERROR(VLOOKUP($A102,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":12403.099999999995},null,null,2.9435491289380938E-5,13872.899999999996]
["ROLLER","ROLLER",null,null,5.5213520944763072E-4,{"$f":"IFERROR(VLOOKUP($A103,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":244580.75},null,null,5.4762674566835069E-4,258095.61]
["SCRAPERS","SCRAPERS",null,null,0,{"$f":"IFERROR(VLOOKUP($A104,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":""},null,null,0,""]
["SKID STEER LOADER","SKID STEER LOADER",null,null,1.066704128538217E-2,{"$f":"IFERROR(VLOOKUP($A105,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":4725206.6399999997},null,null,1.1440874337255656E-2,5392065.79]
["SKIDSTEER / UNILOADER","SKIDSTEER / UNILOADER",null,null,5.1252519432890401E-5,{"$f":"IFERROR(VLOOKUP($A106,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":22703.460000000006},null,null,1.8637175443439219E-4,87836.709999999963]
["Soundproof Generators","Soundproof Generators",null,null,2.5771505731824004E-5,{"$f":"IFERROR(VLOOKUP($A107,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":11416.070000000002},null,null,2.7366865560249395E-5,12897.96]
["SPRAYING EQUIPMENT","SPRAYING EQUIPMENT",null,null,8.2528698822234528E-2,{"$f":"IFERROR(VLOOKUP($A108,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":36557949.410000004},null,null,8.0359731536884638E-2,37873413.040000007]
["Sugar Cane Harvesters","Sugar Cane Harvesters",null,null,1.3651893766621524E-3,{"$f":"IFERROR(VLOOKUP($A109,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":604741.43999999994},null,null,1.4003896629424374E-3,660001.40999999992]
["Telehandlers","Telehandlers",null,null,6.0071792697126191E-3,{"$f":"IFERROR(VLOOKUP($A110,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":2661015.61},null,null,5.8723834827486788E-3,2767644.9499999993]
["TRAILER - on Farm","TRAILER - on Farm",null,null,5.0160059000464729E-4,{"$f":"IFERROR(VLOOKUP($A111,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":222195.3},null,null,5.3533775852507054E-4,252303.83000000002]
["TRUCK - on Farm","TRUCK - on Farm",null,null,1.1453932816547419E-4,{"$f":"IFERROR(VLOOKUP($A112,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":50737.779999999992},null,null,1.1955703602724734E-4,56347.039999999994]
["UNDER 40 HP TRACTORS","UNDER 40 HP TRACTORS",null,null,2.1795888867872279E-3,{"$f":"IFERROR(VLOOKUP($A113,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":965498.08000000007},null,null,2.3386006739269144E-3,1102178.76]
["WHEEL LOADERS","WHEEL LOADERS",null,null,8.226468267491651E-3,{"$f":"IFERROR(VLOOKUP($A114,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":3644099.75},null,null,8.4565833769684896E-3,3985574.2299999995]
["WHEEL LOADERS (OLD)","WHEEL LOADERS (OLD)",null,null,6.9728133150687694E-5,{"$f":"IFERROR(VLOOKUP($A115,[7]Collateral!$A$1:$C$43,3,FALSE),\"\")","v":30887.649999999907},null,null,2.4952100316561149E-4,117598.84999999983]
[null,"Total",null,null,{"$f":"SUM(E73:E114)","v":0.99993027186684935},{"$f":"SUM(F73:F115)","v":442972565.07999998},{"$f":"F70-F116","v":0},null,0.99975047899683434,471298401.7700001,-1.3113021850585938E-6]
["$ 0 - $25,000"]
["$ 25,001 to $50,000","Contract Balance Distribution"]
["$0 - $25,000","$ 0 - $25,000",null,null,{"$f":"IFERROR(F119/F$130,0)","v":3.5033566282366299E-2},{"$f":"IFERROR(VLOOKUP($A119,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":15518908.720000001},null,null,3.3400737305453877E-2,15741714.110000027]
["$25,001 - $50,000","$ 25,001 to $50,000",null,null,{"$f":"IFERROR(F120/F$130,0)","v":8.6514498799894937E-2},{"$f":"IFERROR(VLOOKUP($A120,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":38323549.450000048},null,null,8.5539954026141965E-2,40314843.619999982]
["$50,001 - $75,000","$ 50,001 to $75,000",null,null,7.8508730001640853E-2,{"$f":"IFERROR(VLOOKUP($A121,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":34777213.510000005},null,null,8.034300020495054E-2,37865527.589999974]
["$75,001 - $100,000","$ 75,001 to $100,000",null,null,7.1484724938397068E-2,{"$f":"IFERROR(VLOOKUP($A122,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":31665771.969999999},null,null,7.1824447214059534E-2,33850747.179999985]
["$100,001 - $125,000","$100,001 to $125,000",null,null,6.6718574805332498E-2,{"$f":"IFERROR(VLOOKUP($A123,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":29554498.219999999},null,null,6.5812955154337591E-2,31017540.579999991]
["$125,001 - $150,000","$125,001 to $150,000",null,null,6.5740200670758892E-2,{"$f":"IFERROR(VLOOKUP($A124,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":29121105.320000004},null,null,6.2629829953051414E-2,29517338.760000005]
["$150,001 - $200,000","$150,000 to $200,000",null,null,0.11683310423672252,{"$f":"IFERROR(VLOOKUP($A125,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":51753859.869999997},null,null,0.11830867104703438,55758687.579999976]
["$200,001 - $300,000","$200,001 to $300,000",null,null,0.17389880013469478,{"$f":"IFERROR(VLOOKUP($A126,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":77032397.560000002},null,null,0.17331247074727382,81681890.470000029]
["$300,001 - $400,000","$300,001 to $400,000",null,null,0.12008474328515854,{"$f":"IFERROR(VLOOKUP($A127,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":53194246.75999999},null,null,0.11434657868052715,53891359.780000001]
["$400,001 - $500,000","$400,001 to $500,000",null,null,7.643114928321916E-2,{"$f":"IFERROR(VLOOKUP($A128,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":33856902.25},null,null,7.3609737609359072E-2,34692151.68999999]
["$500,001+","$500,000+",null,null,0.10875190756181444,{"$f":"IFERROR(VLOOKUP($A129,'[7] Balance Distribution'!$A$1:$C$17,3,FALSE),\"\")","v":48174111.449999996},null,null,0.12087161805781058,56966600.409999996]
["$200,001 to $300,000","Total",null,null,{"$f":"SUM(E119:E129)","v":1},{"$f":"SUM(F119:F129)","v":442972565.08000004},{"$f":"F116-F130","v":0},null,0.99999999999999989,471298401.76999998,0]
["0"]
["0 to 5","Residual / Balloon Payment Distribution"]
[0,0,null,null,{"$f":"IFERROR(F133/F$143,0)","v":0.84684907254301878},{"$f":"IFERROR(VLOOKUP($A133,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":375130905.89999986},null,null,0.84363295906960323,397602865.28999889]
["0 to 5","0 to 5",null,null,{"$f":"IFERROR(F134/F$143,0)","v":7.5499235475136138E-5},{"$f":"IFERROR(VLOOKUP($A134,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":33444.089999999975},null,null,5.2552925931811734E-5,24768.11]
["6 to 10","06 to 10",null,null,1.7444772451324208E-3,{"$f":"IFERROR(VLOOKUP($A135,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":772755.56},null,null,2.0107607758501952E-3,947668.34000000008]
["11 to 15","11 to 15",null,null,8.0832683833441023E-3,{"$f":"IFERROR(VLOOKUP($A136,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":3580666.13},null,null,7.9610463687314805E-3,3752028.43]
["16 to 20","16 to 20",null,null,1.62159527615502E-2,{"$f":"IFERROR(VLOOKUP($A137,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":7183222.1899999985},null,null,1.6329229064001236E-2,7695939.5599999977]
["21 to 25","21 to 25",null,null,2.1919345271972895E-2,{"$f":"IFERROR(VLOOKUP($A138,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":9709668.5999999996},null,null,2.1914362283452692E-2,10328203.919999998]
["26 to 30","26 to 30",null,null,4.6088460752220457E-2,{"$f":"IFERROR(VLOOKUP($A139,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":20415923.679999992},null,null,4.7024202409274483E-2,22162431.439999998]
["31 to 35","31 to 35",null,null,1.8230595631902297E-2,{"$f":"IFERROR(VLOOKUP($A140,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":8075653.7100000009},null,null,1.7998190272114706E-2,8482518.3100000024]
["36 to 40","36 to 40",null,null,2.8974723745435638E-2,{"$f":"IFERROR(VLOOKUP($A141,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":12835007.700000003},null,null,2.8893482152408261E-2,13617451.960000001]
["41+ %","41+%",null,null,1.1818604429948192E-2,{"$f":"IFERROR(VLOOKUP($A142,'[7]Residual '!$A$1:$C$14,3,FALSE),\"\")","v":5235317.5199999996},null,null,1.4183214678631893E-2,6684526.4100000001]
[null,null,null,null,{"$f":"SUM(E133:E142)","v":1},{"$f":"SUM(F133:F142)","v":442972565.0799998},{"$f":"F130-F143","v":0},null,1,471298401.76999891,1.0728836059570313E-6]
["2004 Q1"]
["2004 Q2","Quarter of Maturity Distribution"]
[{"$f":"RIGHT(B146,2)&LEFT(B146,4)","v":"Q32020"},"2020Q3",null,null,{"$f":"F146/F$174","v":0},{"$f":"IFERROR(VLOOKUP($A146,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":0},null,null,0,0]
["Q42020","2020Q4",null,null,0,{"$f":"IFERROR(VLOOKUP($A147,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":0},null,null,0,0]
["Q12021","2021Q1",null,null,0,{"$f":"IFERROR(VLOOKUP($A148,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":0},null,null,0,0]
["Q22021","2021Q2",null,null,2.0530217257038437E-4,{"$f":"IFERROR(VLOOKUP($A149,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":90943.23},null,null,2.2783461517529601E-4,107378.09]
["Q32021","2021Q3",null,null,9.5075820310438249E-5,{"$f":"IFERROR(VLOOKUP($A150,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":42115.98},null,null,3.0863098719139124E-3,1454572.9100000001]
["Q42021","2021Q4",null,null,2.6813072944720504E-3,{"$f":"IFERROR(VLOOKUP($A151,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":1187745.5699999994},null,null,5.4383971394217278E-3,2563107.88]
["Q12022","2022Q1",null,null,1.1338181088241764E-2,{"$f":"IFERROR(VLOOKUP($A152,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":5022503.1600000011},null,null,1.1510557726540796E-2,5424907.4600000018]
["Q22022","2022Q2",null,null,8.0364292523558058E-3,{"$f":"IFERROR(VLOOKUP($A153,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":3559917.6799999988},null,null,9.1619526265808351E-3,4318013.6300000008]
["Q32022","2022Q3",null,null,2.5108293778851364E-3,{"$f":"IFERROR(VLOOKUP($A154,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":1112228.5299999998},null,null,3.0801195262877795E-3,1451655.41]
["Q42022","2022Q4",null,null,1.4701613448281763E-2,{"$f":"IFERROR(VLOOKUP($A155,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":6512411.4199999981},null,null,1.5916140669750688E-2,7501251.6599999964]
["Q12023","2023Q1",null,null,2.8466499088318685E-2,{"$f":"IFERROR(VLOOKUP($A156,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":12609878.120000012},null,null,2.8252876266909491E-2,13315535.430000007]
["Q22023","2023Q2",null,null,2.7200286044405424E-2,{"$f":"IFERROR(VLOOKUP($A157,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":12048980.48},null,null,2.8508839897481847E-2,13436170.680000005]
["Q32023","2023Q3",null,null,1.8623723748016088E-2,{"$f":"IFERROR(VLOOKUP($A158,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":8249798.6800000006},null,null,2.23910570678106E-2,10552869.409999998]
["Q42023","2023Q4",null,null,4.8921440938642057E-2,{"$f":"IFERROR(VLOOKUP($A159,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":21670856.18},null,null,4.9521756624564164E-2,23339524.75]
["Q12024","2024Q1",null,null,0.11618372187610607,{"$f":"IFERROR(VLOOKUP($A160,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":51466201.300000027},null,null,0.11451445281229357,53970478.590000041]
["Q22024","2024Q2",null,null,8.4424345655009239E-2,{"$f":"IFERROR(VLOOKUP($A161,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":37397668.950000003},null,null,8.3076030754518651E-2,39153600.520000003]
["Q32024","2024Q3",null,null,2.9076143999287884E-2,{"$f":"IFERROR(VLOOKUP($A162,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":12879934.090000007},null,null,3.0218306802046409E-2,14241839.699999992]
["Q42024","2024Q4",null,null,3.8582986210248395E-2,{"$f":"IFERROR(VLOOKUP($A163,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":17091204.370000005},null,null,3.8470166824049898E-2,18130928.139999993]
["Q12025","2025Q1",null,null,0.12217463806189903,{"$f":"IFERROR(VLOOKUP($A164,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":54120012.810000025},null,null,0.11781612186985034,55526549.940000005]
["Q22025","2025Q2",null,null,0.1149274559267701,{"$f":"IFERROR(VLOOKUP($A165,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":50909709.95000001},null,null,0.1127537881741712,53140680.160000011]
["Q32025","2025Q3",null,null,7.2351657182678705E-2,{"$f":"IFERROR(VLOOKUP($A166,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":32049799.170000002},null,null,7.323749178942604E-2,34516712.829999991]
["Q42025","2025Q4",null,null,0.11206406760435576,{"$f":"IFERROR(VLOOKUP($A167,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":49641307.480000012},null,null,0.11004406400535627,51863591.489999995]
["Q12026","2026Q1",null,null,0.12941589206466253,{"$f":"IFERROR(VLOOKUP($A168,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":57327689.669999987},null,null,0.12465262506591331,58748582.969999976]
["Q22026","2026Q2",null,null,8.1172524067051836E-3,{"$f":"IFERROR(VLOOKUP($A169,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":3595720.1199999996},null,null,8.5931436533417793E-3,4049934.8699999996]
["Q32026","2026Q3",null,null,1.8594819068563338E-3,{"$f":"IFERROR(VLOOKUP($A170,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":823699.47},null,null,1.9425427214726371E-3,915517.28]
["Q42026","2026Q4",null,null,2.1313638234672404E-3,{"$f":"IFERROR(VLOOKUP($A171,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":944135.7},null,null,2.0190075680850111E-3,951555.04]
["Q12027","2027Q1",null,null,5.9103050084539097E-3,{"$f":"IFERROR(VLOOKUP($A172,'[7]Quarter of Maturity Dist'!$A$1:$C$27,3,FALSE),0)","v":2618102.9700000002},null,null,5.5664159270378257E-3,2623442.9300000002]
[]
[null,null,null,null,{"$f":"SUM(E146:E172)","v":0.99999999999999989},{"$f":"SUM(F146:F172)","v":442972565.0800001},{"$f":"F143-F174","v":0},null,1,471298401.76999998,-1.0728836059570313E-6]
["0 to 6 months"]
["07 to 12 months","Seasoning Distribution"]
["0 to 6 months","0 to 6 months",null,null,{"$f":"F177/F$188","v":0},{"$f":"IFERROR(VLOOKUP($A177,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0.13063733526099797,61569167.32]
["07 to 12 months","07 to 12 months",null,null,{"$f":"F178/F$188","v":0.33286185385627931},{"$f":"IFERROR(VLOOKUP($A178,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":147448669.22000024},null,null,0.40204383173883557,189482615.33999997]
["13 to 18 months","13 to 18 months",null,null,0.40384734182734794,{"$f":"IFERROR(VLOOKUP($A179,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":178893292.91000003},null,null,0.20871593309158878,98367485.690000027]
["19 to 24 months","19 to 24 months",null,null,1.1869684229880965E-2,{"$f":"IFERROR(VLOOKUP($A180,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":5257944.47},null,null,0,0]
["25 to 30 months","25 to 30 months",null,null,8.0765086644900355E-2,{"$f":"IFERROR(VLOOKUP($A181,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":35776717.599999987},null,null,0.16072410824122951,75749015.339999944]
["31 to 36 months","31 to 36 months",null,null,0.16021495195121815,{"$f":"IFERROR(VLOOKUP($A182,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":70970828.230000108},null,null,9.3527671841143606E-2,44079442.260000005]
["37 to 42 months","37 to 42 months",null,null,9.03214324182227E-3,{"$f":"IFERROR(VLOOKUP($A183,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":4000991.6600000011},null,null,5.8009033973643897E-4,273395.64999999997]
["43 to 48 months","43 to 48 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A184,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0,0]
["49 to 54 months","49 to 54 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A185,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,1.6965033129694244E-4,79955.929999999964]
["55 to 60 months","55 to 60 months",null,null,4.2837826754740322E-4,{"$f":"IFERROR(VLOOKUP($A186,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":189759.81999999986},null,null,3.5665077023119135E-3,1680889.3799999994]
["60+ months","61 to 72 months",null,null,9.8055998100368799E-4,{"$f":"IFERROR(VLOOKUP($A187,'[7]Seasoning Distribution'!$A$1:$C$12,3,FALSE),0)","v":434361.17000000004},null,null,3.487145285932974E-5,16434.86]
["61 to 72 months","Total",null,null,{"$f":"SUM(E177:E187)","v":1},{"$f":"SUM(F177:F187)","v":442972565.08000034},{"$f":"F174-F188","v":0},null,1,471298401.76999992,0]
[]
[null,"Remaining Term Distribution"]
["0 - 12 months","0-12 Months",null,null,{"$f":"F191/F$197","v":3.0436337016864899E-2},{"$f":"IFERROR(VLOOKUP($A191,'[7]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":13482462.279999994},null,null,3.1742072482776329E-2,14959988.029999994]
["13 - 24 months","13-24 Months",null,null,{"$f":"F192/F$197","v":9.4481483977323796E-2},{"$f":"IFERROR(VLOOKUP($A192,'[7]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":41852705.310000025},null,null,8.3382549532128356E-2,39298062.329999991]
["25 - 36 months","25-36 Months",null,null,0.28554027104851731,{"$f":"IFERROR(VLOOKUP($A193,'[7]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":126486506.30000013},null,null,0.28167750323665613,132754157.09000017]
["37 - 48 months","37-48 Months",null,null,0.39087082130860668,{"$f":"IFERROR(VLOOKUP($A194,'[7]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":173145050.32999974},null,null,0.31163604622550012,146873570.52000019]
["49 - 60 months","49-60 Months",null,null,0.19092065750104922,{"$f":"IFERROR(VLOOKUP($A195,'[7]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":84572613.379999876},null,null,0.28280869597568875,133287286.42000008]
["60+ Months","60+ Months",null,null,7.750429147637997E-3,{"$f":"IFERROR(VLOOKUP($A196,'[7]Remaining Term'!$A$1:$C$10,3,FALSE),0)","v":3433227.48},null,null,8.7531325472502159E-3,4125337.38]
[null,null,null,null,{"$f":"SUM(E191:E196)","v":0.99999999999999989},{"$f":"SUM(F191:F196)","v":442972565.0799998},{"$f":"F188-F197","v":5.3644180297851563E-7},null,0.99999999999999989,471298401.77000046,-5.3644180297851563E-7]
[]
[null,"Origination LVR Distribution"]
["01. 10% to 20%","10% to 20%",null,null,{"$f":"F200/F$216","v":3.4898305716084542E-4},{"$f":"IFERROR(VLOOKUP($A200,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":154589.92000000004},null,null,3.280085810166665E-4,154589.92000000004]
["02. 21% to 30%","21% to 30%",null,null,3.6221505720342461E-3,{"$f":"IFERROR(VLOOKUP($A201,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":1604513.33},null,null,3.7442827588055135E-3,1764674.48]
["03. 31% to 40%","31% to 40%",null,null,1.6676373352074038E-2,{"$f":"IFERROR(VLOOKUP($A202,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":7387175.879999999},null,null,1.6329300080579864E-2,7695973.0300000003]
["04. 41% to 50%","41% to 50%",null,null,6.8335010057639103E-2,{"$f":"IFERROR(VLOOKUP($A203,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":30270534.690000009},null,null,6.701630411090137E-2,31584677.020000007]
["05. 51% to 60%","51% to 60%",null,null,0.10517310315049899,{"$f":"IFERROR(VLOOKUP($A204,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":46588799.279999994},null,null,0.10368003516771221,48864234.87000002]
["06. 61% to 70%","61% to 70%",null,null,0.16136145266037205,{"$f":"IFERROR(VLOOKUP($A205,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":71478696.590000033},null,null,0.16034156592977114,75568723.760000005]
["07. 71% to 80%","71% to 80%",null,null,0.17964150273195512,{"$f":"IFERROR(VLOOKUP($A206,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":79576257.26000002},null,null,0.17803206046293293,83906225.560000062]
["08. 81% to 90%","81% to 90%",null,null,0.20997928181670036,{"$f":"IFERROR(VLOOKUP($A207,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":93015061.080000013},null,null,0.21068681762357894,99296360.419999942]
["09. 91% to 100%","91% to 100%",null,null,0.25486214260156487,{"$f":"IFERROR(VLOOKUP($A208,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":112896937.05},null,null,0.25984162528470461,122462942.71000016]
["> 100%","> 100%",null,null,0,{"$f":"IFERROR(VLOOKUP($A209,'[7]LVR Band'!$A$1:$C$18,3,FALSE),0)","v":0},null,null,0,0]
[null,null,null,null,{"$f":"SUM(E200:E209)","v":0.99999999999999956},{"$f":"SUM(F200:F209)","v":442972565.0800001},{"$f":"F197-F210","v":0},null,1.0000000000000033,471298401.77000022,0]
[]
[null,"New v Used"]
["New","New",null,null,{"$f":"F213/F$216","v":0.84419601690787405},{"$f":"IFERROR(VLOOKUP($A213,'[7]New v Used'!$A$1:$C$9,3,FALSE),0)","v":373955675.0400002},null,null,0.84225900034712897,396955320.73999864]
["USed","Used",null,null,{"$f":"F214/F$216","v":0.15580398309212593},{"$f":"IFERROR(VLOOKUP($A214,'[7]New v Used'!$A$1:$C$9,3,FALSE),0)","v":69016890.040000007},null,null,0.15774099965287106,74343081.030000046]
["Used"]
[null,null,null,null,{"$f":"SUM(E213:E214)","v":1},{"$f":"SUM(F213:F214)","v":442972565.08000022},{"$f":"F210-F216","v":0},null,1,471298401.76999867,1.5497207641601563E-6]
[]
[null,"Contract Type"]
["Finance Lease","Finance Lease",null,null,{"$f":"F219/F$222","v":3.8317274788642105E-3},{"$f":"IFERROR(VLOOKUP($A219,'[7]Loan Type'!$A$1:$C$10,3,FALSE),0)","v":1697350.15},null,null,7.2274432020296188E-3,3406282.4299999997]
["Goods Mortgage","Goods Mortgage",null,null,{"$f":"F220/F$222","v":0.99569816173682035},{"$f":"IFERROR(VLOOKUP($A220,'[7]Loan Type'!$A$1:$C$10,3,FALSE),0)","v":441066968.74999976},null,null,0.99233070047251304,467683873.15999848]
["Hire Purchase","Hire Purchase",null,null,4.7011078431548288E-4,{"$f":"IFERROR(VLOOKUP($A221,'[7]Loan Type'!$A$1:$C$10,3,FALSE),0)","v":208246.17999999996},null,null,4.4185632545732159E-4,208246.17999999996]
[null,null,null,null,{"$f":"SUM(E219:E221)","v":1},{"$f":"SUM(F219:F221)","v":442972565.07999974},{"$f":"F216-F222","v":4.76837158203125E-7},null,1,471298401.76999849,0]
[]
[null,"Contract by Source"]
["Non Hardship Refinance","Non Hardship Refinance",null,null,{"$f":"F225/F$227","v":1},{"$f":"IFERROR(VLOOKUP($A225,'[7]Refinance vs Hardship'!$A$1:$C$7,3,FALSE),0)","v":442972565.07999986},null,null,0.99989184030794809,471247426.27999848]
["Refinance - Hardship","Hardship Refinance",null,null,{"$f":"F226/F$227","v":0},{"$f":"IFERROR(VLOOKUP($A226,'[7]Refinance vs Hardship'!$A$1:$C$7,3,FALSE),0)","v":0},null,null,1.0815969205190921E-4,50975.49000000002]
[null,null,null,null,{"$f":"SUM(E225:E226)","v":1},{"$f":"SUM(F225:F226)","v":442972565.07999986},{"$f":"F222-F227","v":0},null,1,471298401.76999849,0]
[]
[null,"Payment Frequency Distribution"]
["6 Consecutive","6 Consecutive",null,null,{"$f":"F230/F$236","v":1.5764775384540637E-2},{"$f":"IFERROR(VLOOKUP($A230,'[7]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":6983362.9900000002},null,null,1.6609190505636653E-2,7827884.9400000013]
["Annual","Annual",null,null,0.69524064797191332,{"$f":"IFERROR(VLOOKUP($A231,'[7]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":307972533.17999935},null,null,0.68088113835065045,320898192.2999993]
["Monthly","Monthly",null,null,0.22662834607346374,{"$f":"IFERROR(VLOOKUP($A232,'[7]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":100390139.78000006},null,null,0.23667758503122621,111545767.56000002]
["Quarterly","Quarterly",null,null,1.3707637263954247E-2,{"$f":"IFERROR(VLOOKUP($A233,'[7]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":6072107.2399999984},null,null,1.432709929556528E-2,6752338.9999999991]
["Semi Annual","Semi Annual",null,null,2.8199221610358816E-2,{"$f":"IFERROR(VLOOKUP($A234,'[7]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":12491481.529999997},null,null,2.9245064333416483E-2,13783152.079999998]
["Structured","Structured",null,null,2.0459371695769151E-2,{"$f":"IFERROR(VLOOKUP($A235,'[7]Payment Frequency'!$A$1:$C$12,3,FALSE),0)","v":9062940.3599999994},null,null,2.2259922483505046E-2,10491065.890000001]
["0% to 1%",null,null,null,{"$f":"SUM(E230:E235)","v":1},{"$f":"SUM(F230:F235)","v":442972565.07999945},{"$f":"F227-F236","v":0},null,1.0000000000000002,471298401.76999927,-7.7486038208007813E-7]
["1.01% to 2%"]
["2.01% to 3%","Yield Distribution"]
["01. 0% to 1%",null,null,null,{"$f":"F239/F$253","v":0.2176781983836531},{"$f":"IFERROR(VLOOKUP($A239,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":96425469.899999946},null,null,0.21771748396480883,102609902.23000002]
["02. 1.01% to 2%",null,null,null,0.27036373624712157,{"$f":"IFERROR(VLOOKUP($A240,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":119763717.75000004},null,null,0.26666643187840328,125679463.15000007]
["03. 2.01% to 3%",null,null,null,0.31051243481672308,{"$f":"IFERROR(VLOOKUP($A241,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":137548489.74000016},null,null,0.31093564501734766,146543472.55000004]
["04. 3.01% to 4%",null,null,null,0.10232992057152253,{"$f":"IFERROR(VLOOKUP($A242,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":45329347.400000006},null,null,0.10422851196930759,49122731.109999985]
[null,"< 4%",null,null,{"$f":"SUM(E239:E242)","v":0.90088429001902026},{"$f":"SUM(F239:F242)","v":399067024.79000008},null,null,0.89954807282986737,423955569.04000008]
["05. 4.01% to 5%","4% to 5%",null,null,{"$f":"F244/F$253","v":8.6837622445202614E-2},{"$f":"IFERROR(VLOOKUP($A244,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":38466684.359999992},null,null,8.7396721684834436E-2,41189935.249999978]
["06. 5.01% to 6%","5% to 6%",null,null,1.0148851789925395E-2,{"$f":"IFERROR(VLOOKUP($A245,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":4495662.910000002},null,null,1.083162094509133E-2,5104925.6400000015]
["07. 6.01% to 7%","6% to 7%",null,null,2.1076220596898368E-3,{"$f":"IFERROR(VLOOKUP($A246,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":933618.75000000012},null,null,2.2032698733970078E-3,1038397.5700000002]
["08. 7.01% to 8%","7% to 8%",null,null,2.1613686161965582E-5,{"$f":"IFERROR(VLOOKUP($A247,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":9574.2699999999968},null,null,2.0314666809908619E-5,9574.2699999999968]
["09. 8.01% to 9%","8% to 9%",null,null,0,{"$f":"IFERROR(VLOOKUP($A248,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0,0]
["10. 9.01% to 10%","9% to 10%",null,null,0,{"$f":"IFERROR(VLOOKUP($A249,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0,0]
["11. 10.01% to 11%","10% to 11%",null,null,0,{"$f":"IFERROR(VLOOKUP($A250,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0,0]
["12. 11.01% to 12%","11% to 12%",null,null,0,{"$f":"IFERROR(VLOOKUP($A251,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0,0]
["13. > 12%","> 12%",null,null,0,{"$f":"IFERROR(VLOOKUP($A252,'[7]Contract Yield'!$A$1:$C$12,3,FALSE),0)","v":0},null,null,0,0]
[null,null,null,null,{"$f":"SUM(E243:E252)","v":1.0000000000000002},{"$f":"SUM(F243:F252)","v":442972565.0800001},{"$f":"F236-F253","v":-6.5565109252929688E-7},null,1.0000000000000002,471298401.77000004,-7.7486038208007813E-7]
[]
[null,"Top 5 Obligor",null,null,{"$f":"F255/E13","v":4.0952326261387825E-2},{"$f":"SUM('[7]Top 5 Obligor '!$E$2:$E$6)","v":18140757.009999998},null,null,3.920484703662782E-2,18477181.75]